Stored Procedures [dbo].[BAEUpdateOrderProductInfo]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@ProductCodevarchar(31)31
@Titlevarchar(60)60
@Descriptionvarchar(4096)4096
@WebOptiontinyint1
@ImageURLvarchar(100)100
@ThumbnailURLvarchar(100)100
SQL Script
create procedure [dbo].[BAEUpdateOrderProductInfo] @ProductCode varchar(31),
     @Title varchar(60),
     @Description varchar(4096),
     @WebOption tinyint,
     @ImageURL varchar(100),
     @ThumbnailURL varchar(100) as
UPDATE Product
    SET TITLE = @Title,
     WEB_DESC = @Description,
    WEB_OPTION = @WebOption,
     IMAGE_URL = @ImageURL,
    THUMBNAIL_URL = @ThumbnailURL
    WHERE PRODUCT_CODE = @ProductCode;

GO
Uses